NMSCircuitBreaker

V8 Message Definiton

This table contains circuit breaker information for market centers with circuit breakers. Note that circuit breaker records may not always exist for a market center.

METADATA

Attribute	Value
Topic	4440-product-status
MLink Token	SystemData
Product	SRLive
accessType	SELECT

Table Definition

Field	Type	Key	Default Value	Comment
marketCenter	VARCHAR(6)	PRI	''
level1	FLOAT		0	level 1 threshold
level2	FLOAT		0	level 2 threshold
level3	FLOAT		0	level 3 threshold
currentLevel	INT		0	current market circuit breaker level 0 3
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
marketCenter	1

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRLive`.`MsgNMSCircuitBreaker` (
    `marketCenter` VARCHAR(6) NOT NULL DEFAULT '',
    `level1` FLOAT NOT NULL DEFAULT 0 COMMENT 'level 1 threshold',
    `level2` FLOAT NOT NULL DEFAULT 0 COMMENT 'level 2 threshold',
    `level3` FLOAT NOT NULL DEFAULT 0 COMMENT 'level 3 threshold',
    `currentLevel` INT NOT NULL DEFAULT 0 COMMENT 'current market circuit breaker level (0 - 3)',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000',
    PRIMARY KEY USING HASH (`marketCenter`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='This table contains circuit breaker information for market centers with circuit breakers.  Note that circuit breaker records may not always exist for a market center.';

SELECT TABLE EXAMPLE QUERY

SELECT
    `marketCenter`,
    `level1`,
    `level2`,
    `level3`,
    `currentLevel`,
    `timestamp`
FROM `SRLive`.`MsgNMSCircuitBreaker`
WHERE 
    /* Replace with a VARCHAR(6) */ 
    `marketCenter` = 'Example_marketCenter';

Doc Columns Query

SELECT * FROM SRLive.doccolumns WHERE TABLE_NAME='NMSCircuitBreaker' ORDER BY ordinal_position ASC;